{"text_format":"3","workbook":"xlsx","n_sheets":27,"sheets":["Home","Electricity EF","City Profile","Road","Upgrades log","City Parameters","Common parameters","City Graphs data","Rail Parameters","Water Parameters","Water Transport DB","Rail","Water","Road Transport DB","Rail Graphs Data","Off-Hours Deliveries","Fuel emissions factors","Forecast","Results","Distance Reduction","Rail Transport DB","Ecodriving","Fuel Change","Road Graphs data","Road Parameters","Road EF","Water Graphs data"],"not_rendered":{"charts":15,"images":39,"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Electricity EF","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"hidden":true,"merged":[[8,0,8,1]]}
["Energy source for electricity generation","Electricity emission factors (g CO2e per kWh)*"]
["Heavily coal-based",850]
["Fossil-based",500]
["Average EU",320]
["Renewable ongoing",200]
["Largely decarbonized",30]
["Not applicable",0]
["Others",160]
["*The International Energy Agency (IEA) compiles and publishes annually-updated lists of national electricity emission factors, and we recommend cities use this as a source of information. Other available sources can be found here: https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf"]

{"sheet":"City Profile","index":2,"n_rows":168,"n_cols":15,"rows_kept":168,"merged":[[1,1,1,12],[3,3,3,11],[5,3,5,5],[5,7,5,8],[5,9,5,11],[7,3,7,5],[7,7,7,8],[7,9,7,11],[9,3,9,5],[9,7,9,8],[9,9,9,11],[11,3,11,11],[15,1,15,12],[17,2,18,3],[17,5,18,5],[17,7,18,7],[17,9,18,9],[17,11,18,11],[20,2,20,3],[22,2,22,3],[24,2,25,3],[27,1,27,11],[29,2,29,3],[31,2,32,3],[34,2,35,3],[37,2,38,3],[40,2,41,3],[43,2,44,3],[46,1,46,11],[48,2,48,3],[50,2,51,3],[53,2,54,3],[56,2,57,3],[59,2,60,3],[62,2,63,3],[65,1,65,11],[67,2,67,3],[69,2,69,3],[71,2,71,3],[73,2,73,3],[77,1,77,12],[80,2,80,3],[80,5,80,11],[82,2,82,3],[82,5,82,11],[84,2,86,3],[84,5,86,11],[87,2,87,11],[89,2,90,3],[92,2,93,3],[95,2,96,3],[98,2,99,3],[101,2,102,3],[104,1,104,11],[106,2,107,3],[109,2,110,3],[112,2,113,3],[115,1,115,11],[117,2,118,3],[120,2,121,3],[123,2,124,3],[126,1,126,11],[128,2,129,3],[131,2,132,3],[134,2,135,3],[137,1,137,11],[139,2,140,3],[142,2,143,3],[145,2,146,3],[148,1,148,11],[150,2,151,3],[153,2,154,3],[156,2,157,3],[159,1,159,11],[161,2,162,3],[164,2,165,3],[167,2,168,3]]}
[]
[null,"City Properties"]
[]
[null,null,"City name:"]
[]
[null,null,"Country:",{"$nulls":4},"Region:"]
[]
[null,null,"Area (km2):",{"$nulls":4},"Longitude:"]
[]
[null,null,"Boundaries:","Administrative",{"$nulls":3},"Latitude:"]
[]
[null,null,"Climate**:","e.g. Af"]
[]
[]
[]
[null,"City Parameters"]
[]
[null,null,"Year:",null,null,2019,2,2020,null,2021,null,2022]
[]
[]
[null,null,"Population (k):",{"$nulls":11},"*White cells: Optional"]
[]
[null,null,"GDP (million US$):",{"$nulls":11},"*Yellow cells: Mandatory"]
[]
[null,null,"Estimated population growth rate (%):",{"$nulls":11},"**As per the Köppen climate classification"]
[]
[]
[null,"Heavy Goods Vehicle (HGV, with a gross vehicle weight of 3.5 tonnes or more)"]
[]
[null,null,"Number of registered vehicles (k):"]
[]
[null,null,"Annual growth rate of registered vehicles (%):"]
[{"$nulls":4},"*"]
[]
[null,null,"Total urban freight (million tonnes) - Within:"]
[]
[{"$nulls":9},3,null,15]
[null,null,"Total urban freight (million tonnes) - From:"]
[]
[]
[null,null,"Total urban freight (million tonnes) -To:"]
[]
[]
[null,null,"Total urban freight (million tonnes) -Through:"]
[]
[]
[null,"Light Goods Vehicle (LGV, with a GVW up to and including 3.5 tonnes)"]
[]
[null,null,"Number of registered vehicles (k):"]
[]
[null,null,"Annual growth rate of registered vehicles (%):"]
[]
[]
[null,null,"Total urban freight (million tonnes) - Within:"]
[]
[]
[null,null,"Total urban freight (million tonnes) -From:"]
[]
[]
[null,null,"Total urban freight (million tonnes) -To:"]
[]
[]
[null,null,"Total urban freight (million tonnes) -Through:"]
[]
[]
[null,"Total emission reduction target"]
[]
[null,null,"Air transport (%):"]
[]
[null,null,"Rail transport (%):"]
[]
[null,null,"Road transport (%):"]
[]
[null,null,"Inland waterways transport (%):"]
[]
[]
[]
[null,"Air Quality"]
[null,"Air Quality Index (AQI)"]
[]
[null,null,"Index level:",null,null,100]
[]
[null,null,"Risk:",null,null,"Moderate"]
[]
[null,null,"Cautionary statement:",null,null,"Unusually sensitive people should consider reducing prolonged or heavy extension outdoors."]
[]
[]
[]
[{"$nulls":5},{"$f":"F18","v":2019},{"$f":"G18","v":2},2020,0,2021,0,2022]
[null,null,"PM2.5 concentration range [ug/m3]:"]
[]
[]
[null,null,"PM10 concentration range [ug/m3]:"]
[]
[]
[null,null,"NO2 concentration range [ug/m3]:"]
[]
[]
[null,null,"Ozone concentration Rrange [ug/m3]:"]
[]
[]
[null,null,"Number of days exceeding AQI standards (days/year):"]
[]
[]
[null,"Fine particulate matter (PM2.5)"]
[]
[null,null,"Minimum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Maximum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]
[]
[]
[null,"Particulate matter (PM10)"]
[]
[null,null,"Minimum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Maximum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]
[]
[]
[null,"Carbon monoxide (CO)"]
[]
[null,null,"Minimum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Maximum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]
[]
[]
[null,"Nitrogen dioxide (NO2)"]
[]
[null,null,"Minimum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Maximum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]
[]
[]
[null,"Sulphur dioxide (SO2)"]
[]
[null,null,"Minimum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Maximum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]
[]
[]
[null,"Ozone (O3)"]
[]
[null,null,"Minimum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Maximum daily average concentration [ug/m3]:"]
[]
[]
[null,null,"Annual average concentration [ug/m3]:"]

{"sheet":"Road","index":3,"n_rows":43,"n_cols":35,"rows_kept":43,"hidden":true,"merged":[[2,3,4,40],[7,4,8,12],[7,13,8,17],[7,28,8,33],[7,34,8,39],[10,4,11,12],[10,13,11,24],[10,28,11,33],[10,34,11,39],[13,4,14,12],[13,13,14,17],[16,4,17,12],[16,13,17,24],[16,28,17,33],[16,34,17,39],[19,4,20,12],[19,13,20,24],[19,28,20,33],[19,34,20,39],[22,4,23,12],[22,13,23,24],[22,28,23,33],[22,34,23,39],[25,4,26,12],[25,13,26,24],[25,28,26,33],[25,34,26,39],[28,4,29,39],[31,11,32,15],[31,16,32,23],[31,27,32,31],[31,32,32,39],[38,3,39,40],[40,3,41,40],[42,3,46,40]]}
[]
[]
[{"$nulls":3},"Road Transport Input Data"]
[]
[]
[]
[]
[{"$nulls":4},"Year:",{"$nulls":8},2019,{"$nulls":14},"Type of trip flow:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Gross vehicle weight (t):",{"$nulls":8},"Rigid Truck (7.5 t-12t)",{"$nulls":14},"Type of goods: ",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Load factor (%):",{"$nulls":8},60,{"$nulls":20},"Not applicable"]
[]
[]
[{"$nulls":4},"Total distance (million km):",{"$nulls":8},0,{"$nulls":14},"No. of vehicles (k):",{"$nulls":5},0]
[]
[]
[{"$nulls":4},"Million tonne.km:",{"$nulls":8},0,{"$nulls":14},"Age of vehicles:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Fuel type:",{"$nulls":8},"Diesel",{"$nulls":14},"Fuel unit:",{"$nulls":5},"litre"]
[]
[]
[{"$nulls":4},"Fuel consumption (l/100 km)*:",{"$nulls":8},0,{"$nulls":14},"Electricity EF2*, 3*:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Emissions (Million tonnes)"]
[]
[]
[{"$nulls":11},"CO2:",{"$nulls":4},0,{"$nulls":10},"CO2e:",{"$nulls":4},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"*Fuel consumption (liters/100km), (gallons/100km), (kg/100km) or (kWh/100km), depending on the fuel type and its respective unit."]
[]
[{"$nulls":3},"2*Electricity emission factors (g CO2e per kWh), when users choose electricity as the energy type."]
[]
[{"$nulls":3},"3*The International Energy Agency (IEA) compiles and publishes annually-updated lists of national electricity emission factors, and we recommend cities use this as a source of information. Other available sources can be found at https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf."]

{"sheet":"Upgrades log","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"hidden":true}
["2020-03-19","Message when someone selects a vehicle (motorcycle, rickshaw, etc.) and the ef is not known. Spanish version does not include it."]

{"sheet":"City Parameters","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"hidden":true}
["City","Region",null,"Climate",null,"Boundaries"]
["Buenos aires","Africa",null,"Tropical",null,"Administrative"]
["Rosario","East Asia",null,"Dry",null,"Geographic "]
["Santa Fe","Europe",null,"Moderate"]
["Bogotá","Latin America & Caribbean",null,"Continental"]
["Manizales","North Africa, Middle East and West Asia",null,"Polar"]
["Cordoba","North America"]
["Metropolitan Area of the Aburrá Valley (AMVA)","Oceania"]
["Kochi","South Asia"]
["Panaji","Southeast Asia"]
["Shimla"]

{"sheet":"Common parameters","index":6,"n_rows":6,"n_cols":8,"rows_kept":6,"hidden":true,"merged":[[28,0,28,4]]}
["Year","Type of trip flow",null,"Boolean",null,"Off-hour deliveries","Reduction","fuel units"]
[{"$f":"'City Profile'!F$18","v":2019},"Not applicable",null,"Yes ",null,"7PM - 6AM",56,"kg"]
[{"$f":"'City Profile'!H$18","v":2020},"Within",null,"No",null,"6PM - 10PM",13,"litre"]
[{"$f":"'City Profile'!J$18","v":2021},"From ",{"$nulls":3},"6AM - 7PM",0,"gallon"]
[{"$f":"'City Profile'!L$18","v":2022},"To ",{"$nulls":5},"kWh"]
[null,"Through"]

{"sheet":"City Graphs data","index":7,"n_rows":18,"n_cols":7,"rows_kept":18,"hidden":true,"merged":[[1,0,3,0],[4,0,6,0],[7,0,9,0],[10,0,12,0]]}
["year",null,{"$f":"'City Profile'!$F$18","v":2019},{"$f":"'City Profile'!$H$18","v":2020},{"$f":"'City Profile'!$J$18","v":2021},{"$f":"'City Profile'!$L$18","v":2022}]
["Within","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C2+C3","v":0},{"$f":"D2+D3","v":0},0,0]
["From","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C5+C6","v":0},{"$f":"D5+D6","v":0},{"$f":"E5+E6","v":0},{"$f":"F5+F6","v":0}]
["To","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C8+C9","v":0},{"$f":"D8+D9","v":0},{"$f":"E8+E9","v":0},{"$f":"F8+F9","v":0}]
["Through","HGV"]
[null,"LGV"]
[null,"Total",{"$f":"C11+C12","v":0},{"$f":"D11+D12","v":0},{"$f":"E11+E12","v":0},{"$f":"F11+F12","v":0}]
[]
[]
[]
[]
[{"$nulls":6}," "]

{"sheet":"Rail Parameters","index":8,"n_rows":15,"n_cols":24,"rows_kept":15,"hidden":true}
["Type of fuels","Type of goods","Age of Locomotives","Load Characteristics","Payload capacity Wagon (t)","Emission intensity (g CO2e/tkm)  (Ambient, Diesel)","Emission intensity (g CO2e/tkm) (Refrigerated, Diesel)"," uplift values (Asia)","Emission intensity (g CO2e/tkm)  (Ambient, Petrol[gasoline])","Emission intensity (g CO2e/tkm) (Refrigerated, Petrol[gasoline])","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, LPG)","Emission intensity (g CO2e/tkm) (Refrigerated, LPG)","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, CNG)","Emission intensity (g CO2e/tkm) (Refrigerated, CNG)","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, LNG)","Emission intensity (g CO2e/tkm) (Refrigerated, LNG)","uplift values %(Asia)","kWh/t-km  (Electricity)","kWh/t-km (Electricity)","uplift values %","Load factor (%)"]
["Diesel  (litres)","Volume goods","From 0 to 5","Average/mixed",61,28,0,0,{"$nulls":12},0.0322,null,0,60]
["Electricity (kWh)","Average goods","From 5 to 10","Container",65,25,{"$nulls":14},0.0294,null,null,60]
["Diesel (gallons)","Bulk goods","From 10 to 15","Cars",21,60,0,0,{"$nulls":12},0.0693,null,0,50]
[null,"Not applicable","Over 15","Chemicals",55,24,0,0,{"$nulls":12},0.0277,null,0,85]
[null,null,"Not applicable","Coal&Steel",65,19,0,0,{"$nulls":12},0.0215,null,0,100]
[{"$nulls":3},"Building materials",54,23,0,0,{"$nulls":12},0.0268,null,0,100]
[{"$nulls":3},"Manufactured Products",54,24,0,0,{"$nulls":12},0.0282,null,0,100]
[{"$nulls":3},"Cereals",63,18,0,0,{"$nulls":12},0.0212,null,0,75]
[{"$nulls":3},"Truck +trailer on train",63,130,0,0,{"$nulls":12},0,null,0,100]
[{"$nulls":3},"Trailer only on train",63,90,0,0,{"$nulls":12},0,null,0,85]
[]
[]
[]
[{"$nulls":3},61]

{"sheet":"Water Parameters","index":9,"n_rows":12,"n_cols":12,"rows_kept":12,"hidden":true}
["Type of fuels","Cargo Type","Age of vehicles","Type of vessels ","payload","Emission intensity (g CO2e/tkm)  (Ambient, Diesel)","Emission intensity (g CO2e/tkm) (Refrigerated, Diesel)"," uplift values (Asia)","Emission intensity (g CO2e/tkm)  (Ambient, Petrol[gasoline])","Emission intensity (g CO2e/tkm) (Refrigerated, Petrol[gasoline])","uplift values %(Asia)","load factor (%)"]
["Marine Diesel (litres)","Bulk","From 0 to 5","Motor Vessels < 80 m [1000T]",477,30,0,0,{"$nulls":3},55]
[null,"Containers","From 5 to 10","Motor Vessels 85-110 m [1000 - 2000T]",1497,19,0,0,{"$nulls":3},52]
[null,"Pallets","From 10 to 15","Motos Vessels 135 m [2000 - 3000T]",2135,19,0,0,{"$nulls":3},50]
[null,"Mass - limited","Over 15","Coupled convoys [163 -185 m ]",2903,17,0,0,{"$nulls":3},61]
[null,"Volume limited","Not applicable","Pushed convoy - push boat + 2 barges",3000,17,0,0,{"$nulls":3},70]
[null,"Not applicable",null,"Pushed convoy - push boat + 4/5 barges",8000,10,0,0,1000,null,13,70]
[{"$nulls":3},"Pushed convoy - push boat + 6 barges",10000,7.4,0,0,{"$nulls":3},70]
[{"$nulls":3},"Tanker  vessels",4195,21,0,0,{"$nulls":3},65]
[{"$nulls":3},"Container vessels 110m",1410,26,0,0,{"$nulls":3},75]
[{"$nulls":3},"Container vessels 135",3141,20,0,0,{"$nulls":3},75]
[{"$nulls":3},"Container vessels - Coupled convoys",2502,20,0,0,{"$nulls":3},68]

{"sheet":"Water Transport DB","index":10,"n_rows":1,"n_cols":14,"rows_kept":1,"hidden":true}
["Year","Vessel Type (Gross Weight)","Load Factor (%)","Total distance (km)","Total tonne.km (million)","Type of fuel","Fuel efficiency","CO2","CO2e","City Boundaries","Type of goods","Refrigerated","Number of vessels","Age of vessels"]

{"sheet":"Rail","index":11,"n_rows":43,"n_cols":35,"rows_kept":43,"hidden":true,"merged":[[2,3,4,40],[7,4,8,12],[7,13,8,17],[7,28,8,33],[7,34,8,39],[10,4,11,12],[10,13,11,24],[10,28,11,33],[10,34,11,39],[13,4,14,12],[13,13,14,17],[16,4,17,12],[16,13,17,24],[16,28,17,33],[16,34,17,39],[19,4,20,12],[19,13,20,24],[19,28,20,33],[19,34,20,39],[22,4,23,12],[22,13,23,24],[25,4,26,12],[25,13,26,24],[25,28,26,33],[25,34,26,39],[28,4,29,39],[31,11,32,15],[31,16,32,23],[31,27,32,31],[31,32,32,39],[38,3,39,40],[40,3,41,40],[42,3,46,40]]}
[]
[]
[{"$nulls":3},"Rail Transport Input Data"]
[]
[]
[]
[]
[{"$nulls":4},"Year:",{"$nulls":8},2019,{"$nulls":14},"Type of trip flow:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Train type:",{"$nulls":8},"Average",{"$nulls":14},"Type of goods: ",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Load factor (%):",{"$nulls":8},0,{"$nulls":20},"Not applicable"]
[]
[]
[{"$nulls":4},"Total distance (km):",{"$nulls":8},0,{"$nulls":14},"No. of wagons:",{"$nulls":5},20]
[]
[]
[{"$nulls":4},"Million tonne.km:",{"$nulls":8},0,{"$nulls":14},"Age of locomotives",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Type of traction (unit):",{"$nulls":8},"Diesel (litres)"]
[]
[]
[{"$nulls":4},"Fuel consumption (l/100 km)*:",{"$nulls":8},0,{"$nulls":14},"Electriity EF 2*, 3*:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Emissions (Million tonnes)"]
[]
[]
[{"$nulls":11},"CO2:",{"$nulls":4},0,{"$nulls":10},"CO2e:",{"$nulls":4},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"*Fuel consumption (liters/100km), (gallons/100km), (kg/100km) or (kWh/100km), depending on the fuel type and its respective unit."]
[]
[{"$nulls":3},"2*Electricity emission factors (g CO2e per kWh), when users choose electricity as the energy type."]
[]
[{"$nulls":3},"3*The International Energy Agency (IEA) compiles and publishes annually-updated lists of national electricity emission factors, and we recommend cities use this as a source of information. Other available sources can be found at https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf."]

{"sheet":"Water","index":12,"n_rows":39,"n_cols":35,"rows_kept":39,"hidden":true,"merged":[[2,3,4,40],[7,4,8,12],[7,13,8,17],[7,28,8,33],[7,34,8,39],[10,4,11,12],[10,13,11,24],[10,28,11,33],[10,34,11,39],[13,4,14,12],[13,13,14,17],[16,4,17,12],[16,13,17,24],[16,28,17,33],[16,34,17,39],[19,4,20,12],[19,13,20,24],[19,28,20,33],[19,34,20,39],[22,4,23,12],[22,13,23,24],[25,4,26,12],[25,13,26,24],[28,4,29,39],[31,11,32,15],[31,16,32,23],[31,27,32,31],[31,32,32,39],[38,3,39,40]]}
[]
[]
[{"$nulls":3},"Inland Waterways Transport Input Data"]
[]
[]
[]
[]
[{"$nulls":4},"Year:",{"$nulls":8},2019,{"$nulls":14},"Type of trip flow:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Vessel type (gross weight):",{"$nulls":8},"Motor Vessels < 80 m [1000T]",{"$nulls":14},"Type of goods: ",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Load factor (%):",{"$nulls":8},55,{"$nulls":20},"Not applicable"]
[]
[]
[{"$nulls":4},"Total distance (km):",{"$nulls":8},0,{"$nulls":14},"No. of vessels:"]
[]
[]
[{"$nulls":4},"Million tonne.km:",{"$nulls":8},0,{"$nulls":14},"Age of vessels:",{"$nulls":5},"Not applicable"]
[]
[]
[{"$nulls":4},"Fuel type (unit):",{"$nulls":8},"Marine Diesel (litres)"]
[]
[]
[{"$nulls":4},"Fuel consumption (l/100 km)* :",{"$nulls":8},0]
[]
[]
[{"$nulls":4},"Emissions (Million tonnes)"]
[]
[]
[{"$nulls":11},"CO2:",{"$nulls":4},0,{"$nulls":10},"CO2e:",{"$nulls":4},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"*Fuel consumption (liters/100km), (gallons/100km), (kg/100km) or (kWh/100km), depending on the fuel type and its respective unit."]

{"sheet":"Road Transport DB","index":13,"n_rows":1,"n_cols":15,"rows_kept":1,"hidden":true}
["Year","Type of vehicle (Gross vehicle weight)","Load Factor","Total distance (million km)","Total tonne.km (million)","Type of fuel","Fuel unit","Fuel efficiency","CO2","CO2e","City Boundaries","Type of goods","Refrigerated","Number of vehicles","Age of vehicles"]

{"sheet":"Rail Graphs Data","index":14,"n_rows":22,"n_cols":5,"rows_kept":22,"hidden":true}
["Measurement",{"$f":"'City Profile'!$F$18","v":2019},{"$f":"'City Profile'!$H$18","v":2020},{"$f":"'City Profile'!$J$18","v":2021},{"$f":"'City Profile'!$L$18","v":2022}]
["CO2e (million tonnes)",0,0,0,0]
["Million tonne-km",0,0,0,0]
[]
[]
[]
[null,0]
[null,0]
["Average/mixed",0]
["Container",0]
["Cars",0]
["Chemicals",0]
["Coal&Steel",0]
["Building materials",0]
["Manufactured Products",0]
["Cereals",0]
["Truck +trailer on train",0]
["Trailer only on train",0]
[]
["Diesel",0,{"$f":"B20/SUM(B$20:B$21)","v":{"$error":"#DIV/0!"}}]
["Electricity",0,{"$f":"B21/SUM(B$20:B$21)","v":{"$error":"#DIV/0!"}}]
[null,1]

{"sheet":"Off-Hours Deliveries","index":15,"n_rows":33,"n_cols":7,"rows_kept":33,"hidden":true,"merged":[[1,1,2,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[25,2,25,4],[30,1,30,6],[31,1,31,6],[32,1,32,6]]}
[]
[null,"Road Transport - Off-Hour Deliveries Impact Assessment "]
[]
[]
[null,null,"Base year:",{"$f":"'City Profile'!F18","v":2019}]
[null,null,"Forecast year:",2050]
[null,null,"Vehicle type:","Light good vehicle (<3.5 t)"]
[null,null,"Refrigerated:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Road freight transport growth rate (%):",{"$f":"Forecast!I6","v":3},null,"*"]
[null,null," Off-hour periods:","6AM - 7PM",null,"**"]
[]
[]
[{"$nulls":3},"Name",null,"EF (g CO2e/t.km)"]
[null,null,"Fuel used:","Diesel",null,{"v":680,"d":"680.00"}]
[null,null,"Uplifted values (Asia, Africa):",0,null,"%"]
[]
[]
[]
[]
[{"$nulls":3},"Baseline","BAU scenario","Target scenario"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Million km:",{"v":4,"d":"4.00"},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":10.000321381301397,"d":"10.00"}},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":10.000321381301397,"d":"10.00"}}]
[null,null,"Million tonne-km:",{"v":1.8719999999999999,"d":"1.87"},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":4.680150406449053,"d":"4.68"}},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":4.680150406449053,"d":"4.68"}}]
[null,null,"Million tonnes CO2e:",{"v":0.00127296,"d":"0.0013"},{"v":3.2779773446769164E-3,"d":"0.0033"},{"v":3.2779773446769164E-3,"d":"0.0033"}]
[null,null,"CO2e emissions reduced (%):",null,null,{"$f":"IF(F25=0,0,(1-F25/E25)*100)","v":0},"***"]
[]
[]
[]
[]
[null,"*Latest estimate from the International Transport Forum (ITF) suggests that the global freight transport demand grows at 3.1 percent and 3.4 percent annually through 2030 and 2050 respectively (ITF Transport Outlook 2019). It must be noted that it can be misleading to rely on global data, and good quality in-country data should be sought whenever possible."]
[null,"**Source: Holguín-Veras, José & Encarnación, Trilce & Gonzalez-Calderon, Carlos & Winebrake, James & Wang, Cara & Kyle, Sofia & Herazo-Padilla, Nilson & Kalahasthi, Lokesh & Adarme, Wilson & Cantillo, Victor & Yoshizaki, Hugo & Garrido, Rodrigo. (2016). Direct impacts of off-hour deliveries on urban freight emissions. Transportation Research Part D: Transport and Environment. "]
[null,"***The magnitude of the emission reductions depends on the extent of the change of delivery time. A study in three major cities in the Americas indicates that OHD produces emissions that are 13 to 56 percent lower than those produced by deliveries made during regular hours in similar routes. However this might not be applicable to other cities or regions."]

{"sheet":"Fuel emissions factors","index":16,"n_rows":32,"n_cols":14,"rows_kept":32,"hidden":true,"merged":[[1,1,1,3],[1,4,1,6],[1,7,2,7],[1,8,1,10],[1,11,1,13]]}
[]
[null,"kg CO2 / kg fuel",null,null,"kg CO2e / kg fuel",null,null,"Density","kg CO2 / l fuel",null,null,"kg CO2e / l fuel"]
[null,"WTT CO2","TTW CO2","WTW CO2","WTT CO2e","TTW CO2e","WTW CO2e",null,"WTT CO2","TTW CO2","WTW CO2","WTT CO2e","TTW CO2e","WTW CO2e"]
["HFO ",{"$f":"D4-C4","v":{"v":0.2678040000000004,"d":"0.27"}},{"v":3.114,"d":"3.11"},{"$f":"1.086*C4","v":{"v":3.3818040000000003,"d":"3.38"}},{"$f":"G4-F4","v":{"v":0.26000000000000023,"d":"0.26"}},3.15,3.41,{"v":0.97,"d":"0.970"},{"$f":"B4*$H4","v":{"v":0.25976988000000034,"d":"0.26"}},{"v":3.02058,"d":"3.02"},{"v":3.28034988,"d":"3.28"},{"v":0.2522000000000002,"d":"0.25"},{"v":3.0555,"d":"3.06"},{"v":3.3077,"d":"3.31"}]
["Marine Diesel (litres)",{"v":0.679672,"d":"0.68"},{"v":3.206,"d":"3.21"},{"$f":"1.212*C5","v":{"v":3.885672,"d":"3.89"}},{"v":0.6864687199999997,"d":"0.69"},{"$f":"1.01*C5","v":{"v":3.23806,"d":"3.24"}},{"v":3.9245287199999996,"d":"3.92"},0.9,{"v":0.6117048,"d":"0.61"},{"v":2.8854,"d":"2.89"},{"v":3.4971048000000002,"d":"3.50"},{"v":0.6178218479999997,"d":"0.62"},{"v":2.914254,"d":"2.91"},{"v":3.532075848,"d":"3.53"}]
["Gasoline",{"v":0.6299999999999999,"d":"0.63"},3.15,{"$f":"1.2*C6","v":3.78},{"v":0.6785000000000001,"d":"0.68"},{"$f":"1.01*C6","v":{"v":3.1814999999999998,"d":"3.18"}},3.86,0.8,{"v":0.5039999999999999,"d":"0.50"},2.52,2.82,{"v":0.5428000000000001,"d":"0.54"},{"v":2.5452,"d":"2.55"},2.88]
["Aviation fuel",{"v":0.5937254901960785,"d":"0.59"},{"$f":"F7/1.02","v":{"v":3.1862745098039214,"d":"3.19"}},3.78,{"v":0.6299999999999999,"d":"0.63"},3.25,3.88,0.745,{"v":0.4423254901960784,"d":"0.44"},{"v":2.3737745098039214,"d":"2.37"},3.02,{"v":0.46934999999999993,"d":"0.47"},{"v":2.42125,"d":"2.42"},{"v":3.1,"d":"3.10"}]
["Diesel",{"v":0.6831683168316829,"d":"0.68"},{"$f":"F8/1.01","v":{"v":3.1782178217821784,"d":"3.18"}},{"$f":"G8/1.01","v":{"v":3.8613861386138613,"d":"3.86"}},0.69,3.21,{"v":3.9,"d":"3.90"},0.832,{"v":0.5683960396039601,"d":"0.57"},{"v":2.6442772277227724,"d":"2.64"},{"v":3.2126732673267324,"d":"3.21"},{"v":0.5740799999999999,"d":"0.57"},{"v":2.6707199999999998,"d":"2.67"},{"v":3.2447999999999997,"d":"3.24"}]
["LPG",{"v":0.3564356435643563,"d":"0.36"},{"$f":"F9/1.01","v":{"v":3.0693069306930694,"d":"3.07"}},{"$f":"G9/1.01","v":{"v":3.4257425742574257,"d":"3.43"}},{"v":0.3599999999999999,"d":"0.36"},{"v":3.1,"d":"3.10"},3.46,0.55,{"v":0.196039603960396,"d":"0.20"},{"v":1.6881188118811883,"d":"1.69"},{"v":1.8841584158415843,"d":"1.88"},{"v":0.19799999999999995,"d":"0.20"},{"v":1.7,"d":"1.70"},{"v":1.903,"d":"1.90"}]
["CNG",{"$nulls":3},{"v":0.3899999999999997,"d":"0.39"},2.68,3.07,0,0,0,0,0,0,0]
["LNG",{"$nulls":3},0.94,2.68,{"$f":"E11+F11","v":3.62},0,0,0,0,0,0,0]
["Biomethane",{"$nulls":3},0.49,{"v":0,"d":"0.00"},{"$f":"E12+F12","v":0.49},0,0,0,0,0,0,0]
["Bio LNG",{"$nulls":3},{"$f":"0.55+0.49","v":1.04},{"v":0,"d":"0.00"},{"$f":"E13+F13","v":1.04},0,0,0,0,0,0,0]
["HFO1 (gallons)",{"$nulls":7},{"$f":"I4/$D$21","v":{"v":0.06872219047619058,"d":"0.07"}},{"$f":"J4/$D$21","v":{"v":0.7990952380952381,"d":"0.80"}},{"$f":"K4/$D$21","v":{"v":0.8678174285714286,"d":"0.87"}},{"v":0.06671957671957678,"d":"0.07"},{"v":0.8083333333333333,"d":"0.81"},{"v":0.8750529100529101,"d":"0.88"}]
["Marine Diesel (gallons)",{"$nulls":7},{"v":0.16182666666666667,"d":"0.16"},{"v":0.7633333333333334,"d":"0.76"},{"v":0.9251600000000001,"d":"0.93"},{"v":0.16344493333333326,"d":"0.16"},{"v":0.7709666666666667,"d":"0.77"},{"v":0.9344116,"d":"0.93"}]
["Gasoline1 (gallons)",{"$nulls":7},{"v":0.1333333333333333,"d":"0.13"},{"v":0.6666666666666667,"d":"0.67"},{"v":0.746031746031746,"d":"0.75"},{"v":0.1435978835978836,"d":"0.14"},{"v":0.6733333333333333,"d":"0.67"},{"v":0.7619047619047619,"d":"0.76"}]
["Diesel1 (gallons)",{"$nulls":7},{"$f":"I8/$D$21","v":{"v":0.1503693226465503,"d":"0.15"}},{"$f":"J8/$D$21","v":{"v":0.6995442401382996,"d":"0.70"}},{"v":0.8499135627848499,"d":"0.85"},{"v":0.15187301587301585,"d":"0.15"},{"v":0.7065396825396825,"d":"0.71"},{"v":0.8584126984126984,"d":"0.86"}]
["LPG 1(gallons)",{"$nulls":7},{"$f":"I9/$D$21","v":{"v":0.051862329090051854,"d":"0.05"}},{"v":0.4465922782754467,"d":"0.45"},{"v":0.4984546073654985,"d":"0.50"},{"v":0.05238095238095237,"d":"0.05"},{"v":0.44973544973544977,"d":"0.45"},{"v":0.5034391534391535,"d":"0.50"}]
[]
[null,null,"litres","Gallon"]
[null,"Conversion",1,3.78]
[]
[]
[]
[]
[{"$nulls":3},"EN 16258, which is in itself drawn from JEC/Concawe 2013"]
[{"$nulls":3},"Derived by SFC from agreed scaling between CO2 and CO2e or TTW and WTW"]
[{"$nulls":3},"IATA RP1678/ICAO"]
[{"$nulls":3},"CCWG/IMO"]
[{"$nulls":3},"Defra/HBEFA/NTM"]
[{"$nulls":3},"Defra"]
[{"$nulls":3},"Original EF above converted to kgC02e/gallon"]

{"sheet":"Forecast","index":17,"n_rows":27,"n_cols":10,"rows_kept":27,"hidden":true,"merged":[[1,1,2,11],[5,2,5,3],[5,6,5,7],[8,7,8,9],[9,3,10,5],[14,1,15,11],[17,2,17,4],[17,5,17,6],[17,7,17,10],[18,3,18,4],[18,5,18,6],[18,7,18,10],[19,3,19,4],[19,5,19,6],[19,7,19,10],[20,3,20,4],[20,5,20,6],[20,7,20,10],[21,3,21,4],[21,5,21,6],[21,7,21,10],[22,3,22,4],[22,5,22,6],[22,7,22,10],[23,3,23,4],[23,5,23,6],[23,7,23,10],[26,1,27,11]]}
[]
[null,"Impact assessment"]
[]
[]
[]
[null,null,"Base year:",null,{"$f":"'City Profile'!F18","v":2019},null,"Freight growth rate (%):",null,3,"*"]
[]
[]
[{"$nulls":6},"Base year","Forecast"]
[{"$nulls":3},"Road freight transport (CO2e million tonnes)",null,null,{"$f":"E6","v":2019},2025,2030,2050]
[{"$nulls":6},0,{"$f":"$G$11*(1+$I$6/100)^($H$10-$G$10)","v":0},{"$f":"$G$11*(1+$I$6/100)^($I$10-$G$10)","v":0},{"$f":"$G$11*(1+$I$6/100)^($J$10-$G$10)","v":0}]
[]
[]
[]
[null,"Action assessment"]
[]
[]
[null,null,"Measure",null,null,"Type",null,"Description"]
[{"$nulls":3},"Fuel technology change",null,"Improve",null,"This includes technologies for promoting high efficiency and alternative fuels, such as biofuels, bio CNG as wel as bio LNG etc."]
[{"$nulls":3},"Distance reduction",null,"Avoid",null,"This involves the reduction of vehicle kilometers travelled (VKT) of a specific type of vehicle."]
[{"$nulls":3},"Increase load factor",null,"Improve",null,"Increase vehicles efficiency utilization of an specific type of vehicle"]
[{"$nulls":3},"Acces restriction (type vehicle)",null,"Shift",null,"Replace a percentage of a type of vehicle with smaller ones"]
[{"$nulls":3},"Eco-driving",null,"Improve",null,"This involves training drivers to drive in eco-friendly ways in order to save fuel and reduce emissions."]
[{"$nulls":3},"Off-hour deliveries",null,"Improve",null,"Also known as “Out of hours” deliveries, this focuses on shifting freight deliveries from peak period to off hour period. "]
[]
[]
[null,"* Latest estimate from the International Transport Forum (ITF) suggests that the global freight transport demand grows at 3.1 percent and 3.4 percent annually through 2030 and 2050 respectively (ITF Transport Outlook 2019).It must be noted that it can be misleading to rely on global data, and good quality in-country data should be sought whenever possible."]

{"sheet":"Results","index":18,"n_rows":8,"n_cols":10,"rows_kept":8,"hidden":true,"merged":[[3,8,3,10],[4,9,4,10],[5,9,5,10],[6,2,6,3],[6,9,6,10]]}
[]
[]
[]
[{"$nulls":3},"City:",{"$f":"'City Profile'!D4","v":0},{"$nulls":3},"CO2e (million tonnes) "]
[{"$nulls":3},"Country:",{"$f":"'City Profile'!D6","v":0},{"$nulls":3},"Road",{"$f":"'Road Graphs data'!$B$2","v":0}]
[{"$nulls":3},"Area (km2):",{"$f":"'City Profile'!D8","v":0},{"$nulls":3},"Rail",{"$f":"'Rail Graphs Data'!B2","v":0}]
[null,null,"Population (k):",null,{"$f":"'City Profile'!F21","v":0},{"$nulls":3},"Inland waterways",{"$f":"'Water Graphs data'!B2","v":0}]
[{"$nulls":3},"GDP (million US$):",{"$f":"'City Profile'!F23","v":0}]

{"sheet":"Distance Reduction","index":19,"n_rows":29,"n_cols":6,"rows_kept":29,"hidden":true,"merged":[[1,1,2,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[12,3,12,4],[13,3,13,4],[24,2,24,4],[28,1,28,6]]}
[]
[null,"Road Transport - Distance Reduction Impact Assessment"]
[]
[]
[null,null,"Base year:",{"$f":"'City Profile'!F18","v":2019}]
[null,null,"Forecast year:",2050]
[null,null,"Vehicle type:","Light good vehicle (<3.5 t)"]
[null,null,"Refrigerated:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Road freight transport growth rate (%):",{"$f":"Forecast!I6","v":3},null,"*"]
[null,null,"Distance reduction rate (%):",12]
[]
[{"$nulls":3},"Name",null,"EF (g CO2e/t.km)"]
[null,null,"Fuel used:","Diesel",null,{"v":680,"d":"680.00"}]
[null,null,"Uplifted values (Asia, Africa):",0,"%"]
[]
[]
[]
[]
[{"$nulls":3},"Baseline","BAU scenario","Target scenario"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Million km:",{"v":0,"d":"0.00"},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)","v":{"v":0,"d":"0.00"}},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)*(1-(D11/100))","v":{"v":0,"d":"0.00"}}]
[null,null,"Million tonne-km:",{"v":0,"d":"0.00"},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)","v":{"v":0,"d":"0.00"}},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)*(1-(D11/100))","v":{"v":0,"d":"0.00"}}]
[null,null,"Million tonnes CO2e:",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null," CO2e emissions reduced (%):",null,null,{"$f":"IF(F24=0,0,(1-F24/E24)*100)","v":0}]
[]
[]
[]
[null,"*Latest estimate from the International Transport Forum (ITF) suggests that the global freight transport demand grows at 3.1 percent and 3.4 percent annually through 2030 and 2050 respectively (ITF Transport Outlook 2019). It must be noted that it can be misleading to rely on global data, and good quality in-country data should be sought whenever possible."]

{"sheet":"Rail Transport DB","index":20,"n_rows":1,"n_cols":14,"rows_kept":1,"hidden":true}
["Year","Train Type","Load Factor (%)","Total distance (km)","Million tonne.km","Type of traction","Fuel consumption","CO2","CO2e","City Boundaries","Type of goods","Refrigerated","Number of wagons","Age of locomotives"]

{"sheet":"Ecodriving","index":21,"n_rows":32,"n_cols":6,"rows_kept":32,"hidden":true,"merged":[[1,1,2,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[25,2,25,4],[30,1,30,6],[31,1,31,6]]}
[]
[null,"Road Transport - Eco-driving Impact Assessment"]
[]
[]
[null,null,"Base year:",{"$f":"'City Profile'!F18","v":2019}]
[null,null,"Forecast year:",2050]
[null,null,"Vehicle type:","Light good vehicle (<3.5 t)"]
[null,null,"Refrigerated:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Road freight transport growth rate (%):",{"$f":"Forecast!I6","v":3},null,"*"]
[null,null,"Eco-driving fuel saving rate (%):",10,null,"**"]
[]
[{"$nulls":3},"Name",null,"EF (gCO2e/t.km)"]
[null,null,"Fuel used:","Diesel",null,{"v":680,"d":"680.00"}]
[null,null,"Uplift Value:",{"v":1,"d":"1.00"},null,0]
[null,null,"Uplifted values (Asia, Africa):",0,"%"]
[]
[]
[]
[]
[{"$nulls":3},"Baseline","BAU scenario","Target scenario"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Million km:",{"v":4,"d":"4.00"},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":10.000321381301397,"d":"10.00"}},{"$f":"D23*(1+$D$10/100)^($E$22-$D$22)","v":{"v":10.000321381301397,"d":"10.00"}}]
[null,null,"Million tonne-km:",{"v":1.8719999999999999,"d":"1.87"},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":4.680150406449053,"d":"4.68"}},{"$f":"D24*(1+$D$10/100)^($E$22-$D$22)","v":{"v":4.680150406449053,"d":"4.68"}}]
[null,null,"Million tonnes CO2e:",{"v":0.00127296,"d":"0.0013"},{"v":3.2779773446769164E-3,"d":"0.0033"},{"v":3.0157391571027634E-3,"d":"0.0030"}]
[null,null,"CO2e emissions reduced (%):",null,null,{"$f":"IF(F25=0,0,(1-F25/E25)*100)","v":{"v":7.999999999999985,"d":"8"}}]
[]
[]
[]
[]
[null,"*Latest estimate from the International Transport Forum (ITF) suggests that the global freight transport demand grows at 3.1 percent and 3.4 percent annually through 2030 and 2050 respectively (ITF Transport Outlook 2019). It must be noted that it can be misleading to rely on global data, and good quality in-country data should be sought whenever possible."]
[null,"**Default value is 10 percent; Source: “ITS4CV” – ITS for Commercial Vehicles. Study of the scope of Intelligent Transport Systems for reducing CO2 emissions and increasing safety of heavy goods vehicles, buses and coaches. (2016). Retrieved from http://erticonetwork.com/wp-content/uploads/2016/09/ITS4CV-Report-final-2016-09-09.pdf"]

{"sheet":"Fuel Change","index":22,"n_rows":32,"n_cols":9,"rows_kept":32,"hidden":true,"merged":[[1,1,2,9],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[12,3,12,4],[12,6,12,7],[13,3,13,4],[13,6,13,7],[14,3,14,4],[14,6,14,7],[24,2,24,4],[29,1,29,9],[30,1,30,9],[31,1,31,9]]}
[]
[null,"Road Transport - Fuel Technology Change Impact Assessment"]
[]
[]
[null,null,"Base year:",{"$f":"'City Profile'!F18","v":2019}]
[null,null,"Forecast year:",2050]
[null,null,"Vehicle type:","Light good vehicle (<3.5 t)"]
[null,null,"Refrigerated:","No"]
[null,null,"Average truck tonne-km (million):",1]
[null,null,"Road freight transport growth rate (%):",{"$f":"Forecast!I6","v":3},null,"*"]
[]
[]
[{"$nulls":3},"Fuel type",null,"EF (gCO2e/t.km)*2","Energy source for electricity generation",null,"EF (gCO2e/kWh)*3"]
[null,null,"Fuel technology used:","Diesel",null,680,"Others",null,160]
[null,null,"Fuel technology to use:","Diesel",null,680,"Average EU",null,320]
[null,null,"Uplifted values (Asia, Africa):",0,"%"]
[]
[]
[]
[{"$nulls":3},"Baseline","BAU scenario","Target scenario"]
[{"$nulls":3},{"$f":"D5","v":2019},{"$f":"D6","v":2050},{"$f":"D6","v":2050}]
[null,null,"Million km:",{"v":0,"d":"0.00"},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)","v":{"v":0,"d":"0.00"}},{"$f":"D22*(1+$D$10/100)^($E$21-$D$21)","v":{"v":0,"d":"0.00"}}]
[null,null,"Million tonne-km:",{"v":0,"d":"0.00"},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)","v":{"v":0,"d":"0.00"}},{"$f":"D23*(1+$D$10/100)^($E$21-$D$21)","v":{"v":0,"d":"0.00"}}]
[null,null,"Million tonnes CO2e:",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"CO2e emissions reduced (%):",null,null,{"$f":"IF(F24=0,0,(1-F24/E24)*100)","v":0}]
[]
[]
[]
[]
[null,"*Latest estimate from the International Transport Forum (ITF) suggests that the global freight transport demand grows at 3.1 percent and 3.4 percent annually through 2030 and 2050 respectively (ITF Transport Outlook 2019). It must be noted that it can be misleading to rely on global data, and good quality in-country data should be sought whenever possible."]
[null,"*2 Refers to kWh/t-km value when users choose electricity as the energy type."]
[null,"*3 Electricity emission factors (g CO2e per kWh)* when users choose electricity as the energy type; The International Energy Agency (IEA) compiles and publishes annually-updated lists of national electricity emission factors, and we recommend cities use this as a source of information. Other available sources can be found at https://www.carbonfootprint.com/docs/2019_06_emissions_factors_sources_for_2019_electricity.pdf"]

{"sheet":"Road Graphs data","index":23,"n_rows":35,"n_cols":5,"rows_kept":35,"hidden":true}
["Measurement",{"$f":"'City Profile'!$F$18","v":2019},{"$f":"'City Profile'!$H$18","v":2020},{"$f":"'City Profile'!$J$18","v":2021},{"$f":"'City Profile'!$L$18","v":2022}]
["CO2e (million tonnes)",0,0,0,0]
["Million tonne-km",0,0,0,0]
[]
[]
[null,"Number"]
["Non Motorized rickshaw/cart",0]
["Bicycle/Cargo bike",0]
["Motorized rickshaw / tuk tuk",0]
["Motorcycle (2-wheeler)",0]
["Tempo",0]
["Light good vehicle (<3.5 t)",0]
["Rigid Truck (3.5 t - 7.5 t))",0]
["Rigid Truck (7.5 t-12t)",0]
["Rigid Truck (12t-20t)",0]
["Rigid Truck (>20t)",0]
["Truck and Trailer (>20t)",0]
[null,0]
[]
["Diesel",0,{"$f":"B20/SUM(B$20:B$27)","v":{"$error":"#DIV/0!"}}]
["CNG",0,{"$f":"B21/SUM(B$20:B$27)","v":{"$error":"#DIV/0!"}}]
["LPG",0,{"$error":"#DIV/0!"}]
["LNG",0,{"$error":"#DIV/0!"}]
["Gasoline",0,{"$error":"#DIV/0!"}]
["Electricity",0,{"$error":"#DIV/0!"}]
["Biomethane",0,{"$error":"#DIV/0!"}]
["Bio LNG",0,{"$error":"#DIV/0!"}]
[null,0,{"$error":"#DIV/0!"}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[null,{"$f":"SUM(B20:B25)","v":0}]

{"sheet":"Road Parameters","index":24,"n_rows":27,"n_cols":23,"rows_kept":27,"hidden":true}
["Type of fuels","Type of goods","Age of vehicles","Type of road vehicles","EF size (tonnes)","Emission intensity (g CO2e/tkm)  (Ambient, Diesel)","Emission intensity (g CO2e/tkm) (Refrigerated, Diesel)"," uplift values (Asia)","Emission intensity (g CO2e/tkm)  (Ambient, Petrol[gasoline])","Emission intensity (g CO2e/tkm) (Refrigerated, Petrol[gasoline])","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, LPG)","Emission intensity (g CO2e/tkm) (Refrigerated, LPG)","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, CNG)","Emission intensity (g CO2e/tkm) (Refrigerated, CNG)","uplift values %(Asia)","Emission intensity (g CO2e/tkm)  (Ambient, LNG)","Emission intensity (g CO2e/tkm) (Refrigerated, LNG)","uplift values %(Asia)","Emission intensity (kWh/tkm)  (Ambient, electricity)","Emission intensity (kWh/tkm) (Refrigerated, electricity)","uplift values %(Asia)"]
["HFO (litres)","Volume goods","From 0 to 5","Non Motorized rickshaw/cart",0.5,0,0,0]
["MDO (litres)","Average goods","From 5 to 10","Bicycle/Cargo bike",0.5,0,0,0]
["Gasoline (litres)","Bulk goods","From 10 to 15","Motorized rickshaw / tuk tuk",0.5,0,0,0]
["Aviation fuel (litres)","Not applicable","Over 15","Motorcycle (2-wheeler)",0.5,0,0,0]
["Diesel (litres)",null,"Not applicable","Tempo",0.75,0,0,13]
["LPG (litres)",null,null,"Light good vehicle (<3.5 t)",1.3,680,780,13,1000,1150,13,660,760,13,620,710,13,{"$nulls":3},1.1,null,13]
["CNG (kg)",null,null,"Rigid Truck (3.5 t - 7.5 t))",2.3,370,415,22,{"$nulls":6},360,405,22,{"$nulls":3},0.5,null,22]
["LNG (kg)",null,null,"Rigid Truck (7.5 t-12t)",5,240,270,22,{"$nulls":6},220,250,22,{"$nulls":3},0.4,null,22]
["HFO (gallons)",null,null,"Rigid Truck (12t-20t)",8.4,150,170,22,{"$nulls":6},150,170,22,180,200,22]
["MDO (gallons)",null,null,"Rigid Truck (>20t)",15.3,120,145,22,{"$nulls":6},120,145,22,140,170,22]
["Gasoline (gallons)",null,null,"Truck and Trailer (>20t)",18.4,90,100,22,{"$nulls":6},90,100,22,90,100,22]
["Diesel (gallons)"]
["LPG (gallons)"]
["Biomethane (kg)"]
["Bio LNG  (kg)"]
[]
[]
["Fuel change impact","Other impact assessment"]
["Diesel","Diesel"]
["CNG","CNG"]
["LPG","LPG"]
["LNG","LNG"]
["Gasoline","Gasoline"]
["Electricity","Biomethane"]
["Biomethane","Bio LNG"]
["Bio LNG"]

{"sheet":"Road EF","index":25,"n_rows":67,"n_cols":5,"rows_kept":67,"hidden":true}
["Type of fuel","Type of road vehicles"," (g CO2e/tkm)  (Ambient)","(g CO2e/tkm) (Refrigerated)"," uplift values (Asia)"]
["Diesel","Non Motorized rickshaw/cart",0,0,0]
["Diesel","Bicycle/Cargo bike",0,0,0]
["Diesel","Motorized rickshaw / tuk tuk",0,0,0]
["Diesel","Motorcycle (2-wheeler)",0,0,0]
["Diesel","Tempo",0,0,13]
["Diesel","Light good vehicle (<3.5 t)",680,780,13]
["Diesel","Rigid Truck (3.5 t - 7.5 t))",370,415,22]
["Diesel","Rigid Truck (7.5 t-12t)",240,270,22]
["Diesel","Rigid Truck (12t-20t)",150,170,22]
["Diesel","Rigid Truck (>20t)",120,145,22]
["Diesel","Truck and Trailer (>20t)",90,100,22]
["Gasoline","Non Motorized rickshaw/cart",0,0,0]
["Gasoline","Bicycle/Cargo bike",0,0,0]
["Gasoline","Motorized rickshaw / tuk tuk",0,0,0]
["Gasoline","Motorcycle (2-wheeler)",0,0,0]
["Gasoline","Tempo",0,0,0]
["Gasoline","Light good vehicle (<3.5 t)",1000,1150,13]
["Gasoline","Rigid Truck (3.5 t - 7.5 t))",0,0,0]
["Gasoline","Rigid Truck (7.5 t-12t)",0,0,0]
["Gasoline","Rigid Truck (12t-20t)",0,0,0]
["Gasoline","Rigid Truck (>20t)",0,0,0]
["Gasoline","Truck and Trailer (>20t)",0,0,0]
["LPG","Non Motorized rickshaw/cart",0,0,0]
["LPG","Bicycle/Cargo bike",0,0,0]
["LPG","Motorized rickshaw / tuk tuk",0,0,0]
["LPG","Motorcycle (2-wheeler)",0,0,0]
["LPG","Tempo",0,0,0]
["LPG","Light good vehicle (<3.5 t)",660,760,13]
["LPG","Rigid Truck (3.5 t - 7.5 t))",0,0,0]
["LPG","Rigid Truck (7.5 t-12t)",0,0,0]
["LPG","Rigid Truck (12t-20t)",0,0,0]
["LPG","Rigid Truck (>20t)",0,0,0]
["LPG","Truck and Trailer (>20t)",0,0,0]
["CNG","Non Motorized rickshaw/cart",0,0,0]
["CNG","Bicycle/Cargo bike",0,0,0]
["CNG","Motorized rickshaw / tuk tuk",0,0,0]
["CNG","Motorcycle (2-wheeler)",0,0,0]
["CNG","Tempo",0,0,0]
["CNG","Light good vehicle (<3.5 t)",620,710,13]
["CNG","Rigid Truck (3.5 t - 7.5 t))",360,405,22]
["CNG","Rigid Truck (7.5 t-12t)",220,250,22]
["CNG","Rigid Truck (12t-20t)",150,170,22]
["CNG","Rigid Truck (>20t)",120,145,22]
["CNG","Truck and Trailer (>20t)",90,100,22]
["LNG","Non Motorized rickshaw/cart",0,0,0]
["LNG","Bicycle/Cargo bike",0,0,0]
["LNG","Motorized rickshaw / tuk tuk",0,0,0]
["LNG","Motorcycle (2-wheeler)",0,0,0]
["LNG","Tempo",0,0,0]
["LNG","Light good vehicle (<3.5 t)",0,0,0]
["LNG","Rigid Truck (3.5 t - 7.5 t))",0,0,0]
["LNG","Rigid Truck (7.5 t-12t)",0,0,0]
["LNG","Rigid Truck (12t-20t)",180,200,22]
["LNG","Rigid Truck (>20t)",140,170,22]
["LNG","Truck and Trailer (>20t)",90,100,22]
["Electricity","Non Motorized rickshaw/cart",0,0,0]
["Electricity","Bicycle/Cargo bike",0,0,0]
["Electricity","Motorized rickshaw / tuk tuk",0,0,0]
["Electricity","Motorcycle (2-wheeler)",0,0,0]
["Electricity","Tempo",0,0,0]
["Electricity","Light good vehicle (<3.5 t)",1.1,0,0]
["Electricity","Rigid Truck (3.5 t - 7.5 t))",0.5,0,0]
["Electricity","Rigid Truck (7.5 t-12t)",0.4,0,0]
["Electricity","Rigid Truck (12t-20t)",0,0,0]
["Electricity","Rigid Truck (>20t)",0,0,0]
["Electricity","Truck and Trailer (>20t)",0,0,0]

{"sheet":"Water Graphs data","index":26,"n_rows":21,"n_cols":20,"rows_kept":21,"hidden":true}
["Measurement",{"$f":"'City Profile'!F18","v":2019},{"$f":"'City Profile'!H18","v":2020},{"$f":"'City Profile'!J18","v":2021},{"$f":"'City Profile'!L18","v":2022}]
["CO2e (million tonnes)",0,0,0,0,{"$nulls":14},8]
["Million tonne-km",0,0,0,0]
[]
[]
[]
["Motor Vessels < 80 m [1000T]",0]
["Motor Vessels 85-110 m [1000 - 2000T]",0]
["Motos Vessels 135 m [2000 - 3000T]",0]
["Coupled convoys [163 -185 m ]",0]
["Pushed convoy - push boat + 2 barges",0]
["Pushed convoy - push boat + 4/5 barges",0]
["Pushed convoy - push boat + 6 barges",0]
["Tanker  vessels",0]
["Container vessels 110m",0]
["Container vessels 135",0]
["Container vessels - Coupled convoys",0]
[]
[]
["Diesel",0]
["Others",0]